A left join is a SQL query that returns all records from the left table and matched records from the right table, useful for fetching related data from databases. It's like combining two datasets with the primary dataset always being returned. Eloquent in Laravel uses the `leftjoin` method to implement this, handling null values can be done using functions like `IFNULL`.